﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ClearTables] 
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	delete from claim
truncate table datafile
truncate table [functionalgroup]
truncate table transactionset
truncate table interchange
truncate table processingerror
truncate table processingstatus
--delete from provider
truncate table subscriber
truncate table claim
--truncate table claimActivity
truncate table claimpayments
truncate table ClaimLineItems
truncate table ClaimPaymentLineItems
truncate table Patient
truncate table BillingPayToProvider

END


